SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE VIEW dbo.vweCargosGenericos
AS
SELECT     idCargoGenerico AS ID, Descripcion, OrdenAscenso, Escalafon, TipoOfertaEducativa, RegimenSalarial, Mnemo, Nivel
FROM         dbo.tb_CargosGenericos

GO
GRANT SELECT ON  [dbo].[vweCargosGenericos] TO [Juntas]
GRANT INSERT ON  [dbo].[vweCargosGenericos] TO [Juntas]
GRANT DELETE ON  [dbo].[vweCargosGenericos] TO [Juntas]
GRANT UPDATE ON  [dbo].[vweCargosGenericos] TO [Juntas]
GRANT SELECT ON  [dbo].[vweCargosGenericos] TO [RegistroTitulos]
GRANT INSERT ON  [dbo].[vweCargosGenericos] TO [RegistroTitulos]
GRANT DELETE ON  [dbo].[vweCargosGenericos] TO [RegistroTitulos]
GRANT UPDATE ON  [dbo].[vweCargosGenericos] TO [RegistroTitulos]
GRANT SELECT ON  [dbo].[vweCargosGenericos] TO [SoloVer]
GO
